Postgres Pro
Downloads
Home   >   mailing lists

UFS2 Snapshots and Postgres - Mailing list pgsql-general

From Eduardo Morras
Subject UFS2 Snapshots and Postgres
Date
Msg-id 4FA8827200CA2458@> (added by postmaster@resmaa13.ono.com)
Whole thread Raw
List pgsql-general
Tree view 
Hi everyone,

I'm using FreeBSD 9 for Postgres and want to know if these actions
are safe for make a backup of the database:

a) call pg_start_backup('b1')
b) take an UFS2 snapshot of data files
c) call pg_stop_backup()
d) change to the snapshot dir and rsync/dd/dump/transfer it to backup
file server

Is it safe to call pg_start_backup('b1',true)?

Thanks in advance

pgsql-general by date:

Previous
From: Pawel Veselov
Date:
Subject: Re: 31.11. Notice Processing - associating notices with calls
Next
From: David Kerr
Date:
Subject: Calculating Replication Lag - units